package cn.cvs.dao;

import cn.cvs.pojo.SysUser;
import org.apache.ibatis.annotations.Param;

import java.awt.print.Pageable;
import java.util.List;
/**
 * 用户信息表(SysUser)表数据库访问层
 *
 * @author makejava
 * @since 2022-11-18 10:11:40
 */
public interface SysUserMapper {

    SysUser login(@Param("loginName") String loginName,@Param("password") String password);

    List<SysUser> list(@Param("pageNo") Integer pageNo,@Param("pageSize") Integer pageSize,@Param("loginName") String loginName,@Param("phonenumber") String phonenumber,@Param("deptId") Integer deptId);

    int count(@Param("loginName") String loginName,@Param("phonenumber") String phonenumber,@Param("deptId") Integer deptId);

    int delete(@Param("userId") Integer userId);

    int add(SysUser sysUser);

    int update(SysUser sysUser);

    SysUser queryById(@Param("id") Integer id);

    List<SysUser> selectSome(@Param("loginName") String loginName,@Param("phonenumber")  String phonenumber);

    int changeStatus(@Param("id") Integer id,@Param("status") char status);
}

